<?php

/**
 * manage newsletter
 */
class NewsletterController extends Controller {

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {
	$this->render('view', array(
	    'model' => $this->loadModel($id),
	));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
	$model = new Subscriber;

	// Uncomment the following line if AJAX validation is needed
	// $this->performAjaxValidation($model);

	if (isset($_POST['Subscriber'])) {
	    $model->attributes = $_POST['Subscriber'];
	    if ($model->save())
		$this->redirect(array('view', 'id' => $model->id));
	}

	$this->render('create', array(
	    'model' => $model,
	));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
	$model = $this->loadModel($id);

	// Uncomment the following line if AJAX validation is needed
	// $this->performAjaxValidation($model);

	if (isset($_POST['Subscriber'])) {
	    $model->attributes = $_POST['Subscriber'];
	    if ($model->save())
		$this->redirect(array('view', 'id' => $model->id));
	}

	$this->render('update', array(
	    'model' => $model,
	));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
	if (Yii::app()->request->isPostRequest) {
	    // we only allow deletion via POST request
	    $this->loadModel($id)->delete();

	    // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
	    if (!isset($_GET['ajax']))
		$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
	}
	else
	    throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
    }

    /**
     * Manages all models.
     */
    public function actionIndex() {
	$model = new Subscriber('search');
	$model->unsetAttributes();  // clear any default values
	if (isset($_GET['Subscriber']))
	    $model->attributes = $_GET['Subscriber'];

	$this->render('index', array(
	    'model' => $model,
	));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer the ID of the model to be loaded
     */
    public function loadModel($id) {
	$model = Subscriber::model()->findByPk($id);
	if ($model === null)
	    throw new CHttpException(404, 'The requested page does not exist.');
	return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model) {
	if (isset($_POST['ajax']) && $_POST['ajax'] === 'subscriber-form') {
	    echo CActiveForm::validate($model);
	    Yii::app()->end();
	}
    }

    /**
     * send newsletter to subscriber or all members...
     */
    public function actionSend() {
	$model = new SendNewsletterForm();

	if (isset($_GET['email'])) {
	    $model->email = $_GET['email'];
	}

	if (r()->isPostRequest) {
	    $model->attributes = $_POST['SendNewsletterForm'];

	    //validate model and send email
	    if ($model->validate()) {

		if ($model->group == 'subscriber') {
		    //get all subscriber
		    $subscribers = db()->createCommand()
			    ->select('email')
			    ->from('{{subscribers}}')
			    ->queryAll();
		} else {

		    //find all members
		    //get all subscriber
		    $subscribers = db()->createCommand()
			    ->select('email')
			    ->from('{{users}}')
			    ->queryAll();
		}

		foreach ($subscribers as $subscriber) {
		    //send email to client
		    EmailHelper::send($subscriber['email'], $model->subject, $model->body);
		}

		user()->setFlash('success', 'Emails has been sent');

		$this->refresh();
	    }
	}

	$this->render('send', array(
	    'model' => $model
	));
    }

}
